BEGIN;
DELETE FROM DICT_PARAM_TYPE;
DELETE FROM DICT_PARAM;

-- module:SYSTEM_INFO
	INSERT INTO DICT_PARAM_TYPE(DICT_TYPE,DICT_TYPE_NAME,ALTER_MODE) VALUES('0002','Gender', 1);
		INSERT INTO DICT_PARAM(DICT_TYPE,DICT_VALUE,DICT_CONTENT) VALUES('0002','0','未知');
		INSERT INTO DICT_PARAM(DICT_TYPE,DICT_VALUE,DICT_CONTENT) VALUES('0002','1','男');
		INSERT INTO DICT_PARAM(DICT_TYPE,DICT_VALUE,DICT_CONTENT) VALUES('0002','2','女');
	INSERT INTO DICT_PARAM_TYPE(DICT_TYPE,DICT_TYPE_NAME,ALTER_MODE) VALUES('0003','Locale', 1);
		INSERT INTO DICT_PARAM(DICT_TYPE,DICT_VALUE,DICT_CONTENT) VALUES('0003','en_US','英语');
		INSERT INTO DICT_PARAM(DICT_TYPE,DICT_VALUE,DICT_CONTENT) VALUES('0003','zh_CN','简体中文');
	INSERT INTO DICT_PARAM_TYPE(DICT_TYPE,DICT_TYPE_NAME,ALTER_MODE) VALUES('0004','Timezone', 1);
		INSERT INTO DICT_PARAM(DICT_TYPE,DICT_VALUE,DICT_CONTENT) VALUES('0004','-12','-12');
		INSERT INTO DICT_PARAM(DICT_TYPE,DICT_VALUE,DICT_CONTENT) VALUES('0004','-11','-11');
		INSERT INTO DICT_PARAM(DICT_TYPE,DICT_VALUE,DICT_CONTENT) VALUES('0004','-10','-10');
		INSERT INTO DICT_PARAM(DICT_TYPE,DICT_VALUE,DICT_CONTENT) VALUES('0004','-9','-9');
		INSERT INTO DICT_PARAM(DICT_TYPE,DICT_VALUE,DICT_CONTENT) VALUES('0004','-8','-8');
		INSERT INTO DICT_PARAM(DICT_TYPE,DICT_VALUE,DICT_CONTENT) VALUES('0004','-7','-7');
		INSERT INTO DICT_PARAM(DICT_TYPE,DICT_VALUE,DICT_CONTENT) VALUES('0004','-6','-6');
		INSERT INTO DICT_PARAM(DICT_TYPE,DICT_VALUE,DICT_CONTENT) VALUES('0004','-5','-5');
		INSERT INTO DICT_PARAM(DICT_TYPE,DICT_VALUE,DICT_CONTENT) VALUES('0004','-4','-4');
		INSERT INTO DICT_PARAM(DICT_TYPE,DICT_VALUE,DICT_CONTENT) VALUES('0004','-3','-3');
		INSERT INTO DICT_PARAM(DICT_TYPE,DICT_VALUE,DICT_CONTENT) VALUES('0004','-2','-2');
		INSERT INTO DICT_PARAM(DICT_TYPE,DICT_VALUE,DICT_CONTENT) VALUES('0004','-1','-1');
		INSERT INTO DICT_PARAM(DICT_TYPE,DICT_VALUE,DICT_CONTENT) VALUES('0004','0','0');
		INSERT INTO DICT_PARAM(DICT_TYPE,DICT_VALUE,DICT_CONTENT) VALUES('0004','1','+1');
		INSERT INTO DICT_PARAM(DICT_TYPE,DICT_VALUE,DICT_CONTENT) VALUES('0004','2','+2');
		INSERT INTO DICT_PARAM(DICT_TYPE,DICT_VALUE,DICT_CONTENT) VALUES('0004','3','+3');
		INSERT INTO DICT_PARAM(DICT_TYPE,DICT_VALUE,DICT_CONTENT) VALUES('0004','4','+4');
		INSERT INTO DICT_PARAM(DICT_TYPE,DICT_VALUE,DICT_CONTENT) VALUES('0004','5','+5');
		INSERT INTO DICT_PARAM(DICT_TYPE,DICT_VALUE,DICT_CONTENT) VALUES('0004','6','+6');
		INSERT INTO DICT_PARAM(DICT_TYPE,DICT_VALUE,DICT_CONTENT) VALUES('0004','7','+7');
		INSERT INTO DICT_PARAM(DICT_TYPE,DICT_VALUE,DICT_CONTENT) VALUES('0004','8','+8');
		INSERT INTO DICT_PARAM(DICT_TYPE,DICT_VALUE,DICT_CONTENT) VALUES('0004','9','+9');
		INSERT INTO DICT_PARAM(DICT_TYPE,DICT_VALUE,DICT_CONTENT) VALUES('0004','10','+10');
		INSERT INTO DICT_PARAM(DICT_TYPE,DICT_VALUE,DICT_CONTENT) VALUES('0004','11','+11');
		INSERT INTO DICT_PARAM(DICT_TYPE,DICT_VALUE,DICT_CONTENT) VALUES('0004','12','+12');
		INSERT INTO DICT_PARAM(DICT_TYPE,DICT_VALUE,DICT_CONTENT) VALUES('0004','13','+13');
	INSERT INTO DICT_PARAM_TYPE(DICT_TYPE,DICT_TYPE_NAME,ALTER_MODE) VALUES('0005','Theme', 1);
		INSERT INTO DICT_PARAM(DICT_TYPE,DICT_VALUE,DICT_CONTENT) VALUES('0005','default','default');
		INSERT INTO DICT_PARAM(DICT_TYPE,DICT_VALUE,DICT_CONTENT) VALUES('0005','office','office');
-- module:USER
	INSERT INTO DICT_PARAM_TYPE(DICT_TYPE,DICT_TYPE_NAME,ALTER_MODE) VALUES('1001','UserType', 1);
		INSERT INTO DICT_PARAM(DICT_TYPE,DICT_VALUE,DICT_CONTENT) VALUES('1001','1','个人');
		INSERT INTO DICT_PARAM(DICT_TYPE,DICT_VALUE,DICT_CONTENT) VALUES('1001','2','企业');
	INSERT INTO DICT_PARAM_TYPE(DICT_TYPE,DICT_TYPE_NAME,ALTER_MODE) VALUES('1002','Status', 1);
		INSERT INTO DICT_PARAM(DICT_TYPE,DICT_VALUE,DICT_CONTENT) VALUES('1002','0','尚未认证');
		INSERT INTO DICT_PARAM(DICT_TYPE,DICT_VALUE,DICT_CONTENT) VALUES('1002','1','正常');
		INSERT INTO DICT_PARAM(DICT_TYPE,DICT_VALUE,DICT_CONTENT) VALUES('1002','2','逻辑删除');
		INSERT INTO DICT_PARAM(DICT_TYPE,DICT_VALUE,DICT_CONTENT) VALUES('1002','3','已删除');
		INSERT INTO DICT_PARAM(DICT_TYPE,DICT_VALUE,DICT_CONTENT) VALUES('1002','4','已锁定');
-- module:USER_GROUP
	INSERT INTO DICT_PARAM_TYPE(DICT_TYPE,DICT_TYPE_NAME,ALTER_MODE) VALUES('userGroup-type','GroupType', 1);
		INSERT INTO DICT_PARAM(DICT_TYPE,DICT_VALUE,DICT_CONTENT) VALUES('userGroup-type','1','部门');
		INSERT INTO DICT_PARAM(DICT_TYPE,DICT_VALUE,DICT_CONTENT) VALUES('userGroup-type','2','团队');
	INSERT INTO DICT_PARAM_TYPE(DICT_TYPE,DICT_TYPE_NAME,ALTER_MODE) VALUES('userGroup-status','Status', 1);
		INSERT INTO DICT_PARAM(DICT_TYPE,DICT_VALUE,DICT_CONTENT) VALUES('userGroup-status','1','正常');
		INSERT INTO DICT_PARAM(DICT_TYPE,DICT_VALUE,DICT_CONTENT) VALUES('userGroup-status','2','已删除');
-- module:affiche
	INSERT INTO DICT_PARAM_TYPE(DICT_TYPE,DICT_TYPE_NAME,ALTER_MODE) VALUES('affiche-type','type', 1);
		INSERT INTO DICT_PARAM(DICT_TYPE,DICT_VALUE,DICT_CONTENT) VALUES('affiche-type','1','公告');
		INSERT INTO DICT_PARAM(DICT_TYPE,DICT_VALUE,DICT_CONTENT) VALUES('affiche-type','2','新闻');
		INSERT INTO DICT_PARAM(DICT_TYPE,DICT_VALUE,DICT_CONTENT) VALUES('affiche-type','3','通知');
-- module:SHORT_MESSAGE
	INSERT INTO DICT_PARAM_TYPE(DICT_TYPE,DICT_TYPE_NAME,ALTER_MODE) VALUES('2001','type', 1);
		INSERT INTO DICT_PARAM(DICT_TYPE,DICT_VALUE,DICT_CONTENT) VALUES('2001','1','系统');
		INSERT INTO DICT_PARAM(DICT_TYPE,DICT_VALUE,DICT_CONTENT) VALUES('2001','2','用户');
-- module:TODO
	INSERT INTO DICT_PARAM_TYPE(DICT_TYPE,DICT_TYPE_NAME,ALTER_MODE) VALUES('2101','status', 1);
		INSERT INTO DICT_PARAM(DICT_TYPE,DICT_VALUE,DICT_CONTENT) VALUES('2101','-2','Delayed');
		INSERT INTO DICT_PARAM(DICT_TYPE,DICT_VALUE,DICT_CONTENT) VALUES('2101','-1','Cancelled');
		INSERT INTO DICT_PARAM(DICT_TYPE,DICT_VALUE,DICT_CONTENT) VALUES('2101','1','New');
		INSERT INTO DICT_PARAM(DICT_TYPE,DICT_VALUE,DICT_CONTENT) VALUES('2101','2','In Progress');
		INSERT INTO DICT_PARAM(DICT_TYPE,DICT_VALUE,DICT_CONTENT) VALUES('2101','3','Done');
-- module:CUSTOMER
	INSERT INTO DICT_PARAM_TYPE(DICT_TYPE,DICT_TYPE_NAME,ALTER_MODE) VALUES('3001','grade', 1);
		INSERT INTO DICT_PARAM(DICT_TYPE,DICT_VALUE,DICT_CONTENT) VALUES('3001','1','1 星');
		INSERT INTO DICT_PARAM(DICT_TYPE,DICT_VALUE,DICT_CONTENT) VALUES('3001','2','2 星');
		INSERT INTO DICT_PARAM(DICT_TYPE,DICT_VALUE,DICT_CONTENT) VALUES('3001','3','3 星');
		INSERT INTO DICT_PARAM(DICT_TYPE,DICT_VALUE,DICT_CONTENT) VALUES('3001','4','4 星');
		INSERT INTO DICT_PARAM(DICT_TYPE,DICT_VALUE,DICT_CONTENT) VALUES('3001','5','5 星');
	INSERT INTO DICT_PARAM_TYPE(DICT_TYPE,DICT_TYPE_NAME,ALTER_MODE) VALUES('3002','status', 1);
		INSERT INTO DICT_PARAM(DICT_TYPE,DICT_VALUE,DICT_CONTENT) VALUES('3002','1','潜在');
		INSERT INTO DICT_PARAM(DICT_TYPE,DICT_VALUE,DICT_CONTENT) VALUES('3002','2','有意向');
		INSERT INTO DICT_PARAM(DICT_TYPE,DICT_VALUE,DICT_CONTENT) VALUES('3002','3','失败');
		INSERT INTO DICT_PARAM(DICT_TYPE,DICT_VALUE,DICT_CONTENT) VALUES('3002','4','已流失');
		INSERT INTO DICT_PARAM(DICT_TYPE,DICT_VALUE,DICT_CONTENT) VALUES('3002','5','已成交');
		INSERT INTO DICT_PARAM(DICT_TYPE,DICT_VALUE,DICT_CONTENT) VALUES('3002','6','维护');
		INSERT INTO DICT_PARAM(DICT_TYPE,DICT_VALUE,DICT_CONTENT) VALUES('3002','7','重点维护');
-- module:PROJECT
	INSERT INTO DICT_PARAM_TYPE(DICT_TYPE,DICT_TYPE_NAME,ALTER_MODE) VALUES('4001','status', 1);
		INSERT INTO DICT_PARAM(DICT_TYPE,DICT_VALUE,DICT_CONTENT) VALUES('4001','-2','中止');
		INSERT INTO DICT_PARAM(DICT_TYPE,DICT_VALUE,DICT_CONTENT) VALUES('4001','-1','取消');
		INSERT INTO DICT_PARAM(DICT_TYPE,DICT_VALUE,DICT_CONTENT) VALUES('4001','1','计划');
		INSERT INTO DICT_PARAM(DICT_TYPE,DICT_VALUE,DICT_CONTENT) VALUES('4001','2','立项');
		INSERT INTO DICT_PARAM(DICT_TYPE,DICT_VALUE,DICT_CONTENT) VALUES('4001','3','启动');
		INSERT INTO DICT_PARAM(DICT_TYPE,DICT_VALUE,DICT_CONTENT) VALUES('4001','4','进行中');
		INSERT INTO DICT_PARAM(DICT_TYPE,DICT_VALUE,DICT_CONTENT) VALUES('4001','5','完成');
-- module:TASK
	INSERT INTO DICT_PARAM_TYPE(DICT_TYPE,DICT_TYPE_NAME,ALTER_MODE) VALUES('4101','status', 1);
		INSERT INTO DICT_PARAM(DICT_TYPE,DICT_VALUE,DICT_CONTENT) VALUES('4101','-2','中止');
		INSERT INTO DICT_PARAM(DICT_TYPE,DICT_VALUE,DICT_CONTENT) VALUES('4101','-1','取消');
		INSERT INTO DICT_PARAM(DICT_TYPE,DICT_VALUE,DICT_CONTENT) VALUES('4101','0','创建');
		INSERT INTO DICT_PARAM(DICT_TYPE,DICT_VALUE,DICT_CONTENT) VALUES('4101','1','进行中');
		INSERT INTO DICT_PARAM(DICT_TYPE,DICT_VALUE,DICT_CONTENT) VALUES('4101','2','暂停');
		INSERT INTO DICT_PARAM(DICT_TYPE,DICT_VALUE,DICT_CONTENT) VALUES('4101','3','完成');
	INSERT INTO DICT_PARAM_TYPE(DICT_TYPE,DICT_TYPE_NAME,ALTER_MODE) VALUES('4102','priority', 1);
		INSERT INTO DICT_PARAM(DICT_TYPE,DICT_VALUE,DICT_CONTENT) VALUES('4102','0','建议');
		INSERT INTO DICT_PARAM(DICT_TYPE,DICT_VALUE,DICT_CONTENT) VALUES('4102','1','次要的');
		INSERT INTO DICT_PARAM(DICT_TYPE,DICT_VALUE,DICT_CONTENT) VALUES('4102','2','主要的');
		INSERT INTO DICT_PARAM(DICT_TYPE,DICT_VALUE,DICT_CONTENT) VALUES('4102','3','严重的');
		INSERT INTO DICT_PARAM(DICT_TYPE,DICT_VALUE,DICT_CONTENT) VALUES('4102','4','阻塞的');
COMMIT;